Results matching “web hosting” from Ye Olde Rad Blog III

Feliz año nuevo. Most Content Management Systems (such as Drupal & MODx) work in conjunction with (require) a database. So do blogs (such as Movable Type) & forums (such as SMF).

MySQL is the world's most popular database software for web-based applications (.. such as CMS's & blogs & forums). It's what I use. It's the only database system I've ever used.

The Rad VPS (« physically located downtown Chicago) uses the cPanel/WHM control panel to help administer the site. cPanel makes it stupid-easy to create a new MySQL database.

You simply » enter a descriptive name for your new DATABASE (such as » rad_modx) and click the button labeled 'Create Database.' cPanel talks to MySQL and creates the database for you. Viola! Done. Too easy.

To use your new DATABASE, you'll also need to create a USER (such as » rad_modx, conveniently same as the database_name). Give this USER a password and click the button labeled » 'Create User.' Voila! Done creating new USER.

Lastly you need to assign a particular USER to a particular DATABASE. You do this by selecting both from their respective drop-down menus (one lists all available DATABASES, the other all possible USERS) and clicking the button labeled 'Add.'

Then you assign to this USER the appropriate PRIVILEDGES (normally ALL) necessary to perform the database functions. Click the button labeled 'Make Changes' and you're done. Voila! As if this weren't easy enough, cPanel even has a wizard to walk you thru these steps.

So, in order to configure a database to work with a particular web application (such as Drupal or MODx), you need 3 pieces of info:

1. database_name
2. user_name
3. user_password

Couldn't be easier. Tho I sometimes forget the final step of actually assigning the USER to the DATABASE (after creating both). Creating new DATABASES is not something I do on a regular basis.

RADIFIED currently uses 5 databases. Three for the blogs » 1-each for the 3 different versions of Movable Type I have installed .. based on v263 (installed 2003), v335 (installed 2007) & v432 (installed 2008). Another for Drupal (2008). And 1 for MODx Revolution (beta5), which I installed a few days ago.

The Rad forum, which uses YaBB, doesn't use a database. (At least not yet.) Might be worth noting here that Movable Type, Drupal, MODx & YaBB are all OPEN SOURCE (better than free) .. as is MySQL.

While installing MODx a few days ago, I noticed they include an option to test your database connection & credentials .. to see if MODx can access it okay.

Created a dedicated 'Guides' page. See here » Radified Guides. Been meaning to do that for .. eons. This will allow me to off-load the guides listed here on the home-page, so I can clean it up.

I indented & right-aligned every other link .. to make them easier to read. What do you think? When the links were all lined-up together & left-aligned, they seemed too .. similar.

Eventually I'd like to include a representative graphic for each guide/link. But for now, I just wanted to create a page that contains a repository of the links to all our guides.

On a related note, I've been looking more deeply into MODx, the Content Management System (CMS). They are fixin' to release a new version (complete-rewrite, from the ground up, based on PHP5) .. called » REVOLUTION. (Current version is called » EVOLUTION.)

Drupal would be cool, but it's way too sophisticated for what I need. I don't want/need a PhD in CMS's. Here's a MODx site, for example. (I used to live in Lancaster, PA .. the heart of Amish country. Nice people there.)

I'd like to become intimately familiar with a good CMS .. as another skill to add to my digital toolkit. Only way to do that is » use one daily.

The good people at MODx claim a 'Release Candidate' version of REVOLUTION will be coming » "Winter 2009" (.. which is now). [ Notice how the words 'Summer 2009' have been lined-out. ] UPDATE » They just changed the RC date to "Spring 2010". Hmmm.

The MODx site is running REVOLUTION. I'm in no hurry, tho. Rather make a good decision than a hasty one.

I'm reluctant to republish the content of others (as so many sites already do), but .. I found it interesting & noteworthy that » Microsoft has acknowledged Linux as a threat .. especially since I spent so many hours in Linux these past few weeks (learning the Unix shell)

Copy-n-paste snippet (minor Rad-editing for brevity):

"Microsoft acknowledges Linux as the first viable competitor to its Windows client business, due to the use of Linux on netbooks, which are rising in prominence as an alternative to full-sized notebooks.

Microsoft cited Red Hat and Canonical -- the latter of which maintains the Ubuntu Linux distribution -- as competitors to its client business, which includes the desktop version of its Windows OS." </snippet>

Notice how the article said » DESKTOP, and not server. Linux has long been a dominant force in the server market (.. if not the dominant force).

It's difficult to describe why Linux is so cool .. why using it feels so fresh & clean. But I think it has something to do with the good intentions .. that come from thousands of talented programmers donating their time & expertise .. to bring you (for free) an operating system they obviously believe in.

I might be imagining it, but I think you can actually feel these good intentions (while using Linux). Can you feel the difference (in intentions) between someone who genuinely loves you, and someone who is paid to love you?

Moreover, I feel our economy has a lot to do with the Linux threat to the Microsoft desktop. No matter how compelling the product, basic economics suggest it's hard to compete with free. (Which Windows is not.) And in these troubled economic times, free means more than it used to.

Last month I mentioned a quest to learn the Unix shell .. specifically » bash (the Bourne Again SHell). Almost done. Currently ~80% complete .. enough to feel reasonably confident at a terminal.

The 'shell' is simply a program that lets you interact with the operating system (actually the kernel, to be more precise) ..

.. by taking your (text-based) commands and passing them on to the kernel. In my case, this kernel happens to be » Linux (which is but one variant of Unix).

The term 'shell' comes from the notion that this software acts like a 'layer' that sits between you and the operating system .. similar to the way an egg-shell sits between you and your hard-boiled breakfast.

The shell can be intimidating, cuz it uses a (text-based) command-line interface (CLI). No intuitive GUI to help you along. You either know the commands or you don't.

Didn't take me long to realize the CLI was where Linux's true power resides. When we upgraded the site, for example, to a Virtual Private Server, the support-techs who helped me with the move all used the command-line to work their mojo.

Most Linux distros do indeed come with an excellent GUI (usually either KDE or Gnome). But (but!) the Rad VPS does not. Which is why it became necessary to learn the Unix shell. (Something I tried to avoid.)

The Rad VPS is based on CentOS (Community ENTerprise Operating System), an off-shoot of Red Hat, which is probably the most popular of all enterprise Linux distros (.. and now a new member of the S&P 500, a development you may find telling).

GUIs (such as KDE or Gnome) require lots of memory/RAM. My laptop, for example, has 2-gigs, but the Rad VPS comes with an allotment of only 512-MB (.. upgraded from 384 just today).

With that limited amount, I need to run not only all the standard web applications .. such as Apache (web server), MySQL (database), Perl (scripting language), etc. but also cPanel/WHM.

So there's not much RAM left to run a GUI. [ Don't think I didn't inquire about installing a GUI. =) ]

Bottom line » if you wanna administer your own VPS, you need to learn the Shell. So that's what I'm doing. (Of course, there have been distractions, making progress uneven.)

Strange coincidences. Ever had 'em? Things that seem highly improbable. Jung termed these attention-getting coincidences » "synchronicity," which he defined as » "two or more events which are causally unrelated, tho occurring together in a meaningful manner".

The easiest one to describe came when I was living in Hawaii (Honolulu, downtown Waikiki, on Ala Wai Blvd). It was a Saturday afternoon when the phone rang .. someone calling for the Dog.

(.. who was out looking for his car. It's easier to lose your car in Waikiki than you might think, cuz you can walk everywhere. I had a black Sportster there.)

The caller was hosting a card game that night and asked me to give the Dog his number. I found a pen and tore off a piece of grocery bag. I forget the number, but recall the last four digits were '0507'.

The radio was on. (We had a nice stereo system, with Bose speakers. Actually, that's pretty-much ALL we had in the place. You know how it is when you're 20 years old.) A commercial was playing as I took down the guy's number. It was playing loud, cuz I had turned up the previous song.

At the exact time I wrote the number, the radio announcer gave the address of the place he was pimping » 507 (Something street) .. for some tire store (in Honolulu).

'Interesting timing,' I thought. But then, I glanced over at the clock to note the time the guy called, and it was » 5:07. That *really* got my attention. My eyebrows popped up as I looked around to see if anybody was watching.

I told the Dog about the weird coincidence when he got home (after finding his car). He was the one who noted today was May 7th (»5:07). He held out his arm and said, "Look. Chills."

Back when I investigated how to create a webpage template, a couple weeks ago, I really had in mind the notion of using a template as the basis for a new Rad guide .. not one on Dreamweaver Templates however, but rather one for » Drive Imaging & Disk Cloning. Today I created that template, and began a new Rad guide.

Definitely takes longer to get up-n-running when using a template, cuz you first must determine exactly how the guide will be structured .. and what items to include in the template, and what parts need to be editable.

Can't just start cranking out pages of text and entertaining new ideas (.. like I used to) .. leaving the details of page structure to deal with later.

Templates force you to pre-think everything up front, before you begin generating content-one. They even force you to anticipate changes .. which is new for me .. especially since I've grown accustomed to the ready-fire-aim approach, which leaves the details of page structure for later .. but by then it's difficult to make changes .. cuz each page must be edited individually (.. hence the need for templates).

I was so eager to get started on the guide that I actually had to start over (several times) .. due to major template modifications. (Arrgh!) Kept getting new ideas .. things I wanted to add/tweak.

You can always modify a template, as that's what they are designed for. But when a template requires many edits, it seems easier to just start over and create a new one. (Something I'm getting good at .. from all the practice.)

If you view this home page in Firefox (or a browser other than IE or Opera), you'll notice I added some rounded corners.

Been reluctant to spend much time focusing on site styling, preferring rather to concentrate on generating » content.

In the world of cars, for example, I've always preferred the spartan cockpit of a Porsche to the bells & whistles you find sitting in a corvette. Tho admittedly, that's just my druthers.

My point » function should never take a back seat to form.

I've considered adding rounded corners many times before. Countless techniques exist. But they always seemed a kludge. (Andy agrees.) So I never felt it worth adding the extra markup necessary.

Techniques that use graphics to achieve their effect involve inserting additional HTML elements that are otherwise unnecessary, because current CSS standards (v2.1) allow only 1 background image per element (while each box has 4 corners). Future versions of CSS (v3.0) will support 8 images per element (for this very reason).

This approach has 2 main problems. First, adding (otherwise) unnecessary markup goes against all that is holy to the Web Standards movement, which touts the tenent of 'Semantic Markup' as one of its pillars.

If I knew then what I know now. Ever uttered those words? Looking back on my progression of web skills, one omission stands out » incorporating the use of templates to help develop & maintain the pages of my web site.

Templates are both powerful & flexible for two reasons:

1. They speed up site development, by allowing the rapid creation of web pages based on a preformed (uniform) structure .. so all your pages have the same look & feel.
   
   
2. They facilitate site maintenance, by enabling structural changes site-wide via the editing of a single-file .. similar to how CSS works. This aspect of templates is considerably more significant than item #1.

If your web site grows bigger than expected (as they usually do), and you want to make structural changes (non CSS-based changes) to your web pages, you'll have to edit each page individually (.. which suks giant goose eggs). Tedious maximus.

When CSS came along, website designers could transfer all style controls into a single file, so that the look of an entire site could be modified by editing a single file (provided, of course, the entire site was based off of the same style sheet). Very cool development.

But what about structural changes? That's where templates come in. To be honest, I'm not sure if web design programs (such as Dreamweaver and Expression) had the ability to generate templates back when I launched the site. But they do now.

Had a weird problem with my network earlier this week .. where I could not access my site .. which (as you might imagine) suks pretty bad. No problems accessing any other sites. Seemed as tho I was being blocked to my site and my site only.

First I called my web host. Can't access my site, I said. No web pages, no email, no FTP, SSH. Nothing. Have no problems accessing any other sites. So it must be a problem with the server.

Hmmm, the tech mutters, I was just checking out your site earlier this morning .. a few hours ago. Lemme try to pull it up.

Your site is loading fine for me, he says.

You must be loading from the browser cache, I argue.

He proceeds to perform his Linux-guru mojo and says, No, your site is fine. These are pages I didn't load this morning.

You sure? I ask.

He then has me check my IP addy and verifies I'm not being blocked .. then suggests I unplug my router (for 30 secs) to reset it before plugging it back in. This trick works! I can again connect to the site. Until...

Upgraded the Rad Community forums .. to » YaBB v2.4 (released a few weeks ago). The boys at YaBB have adopted a new, fast-n-furious (3-month) release cycle, which keeps me hopping.

The 'upgrade' process begins with a new/fresh/clean install of the new version .. to a new/unique directory.

I then configure the new version to make it look like the version currently in-use.

After everything looks hunky dory, and appears to be working correctly, I place both (old & new) forums in Maintenance mode and copy all the member-accounts and posts (» folders labeled /Members and /Messages) .. from old to new directories.

That's always the trickiest part, cuz there are so many files to copy (more than 15,000). Our old Shared hosting server choked on this file-transfer. The forums contain ~5K threads with 40K posts (which I'd hate to lose).

Our new VPS however, seems to be handling the load much better. And I can now work from the (powerful) Linux shell (command line).

Upgraded the Rad Community Forums to the latest version of YaBB (» v2.3.1), which was released in Jan.04. Had to wait until the mods I use were upgraded to Y.231-compatible.

No matter how many times I perform this upgrade, I always get antsy .. about the prospect of losing 40,000 posts (which would suk gigantic goose eggs).

A tech from our ISP come out today (to install wired connections, using the home's pre-existing electrical wiring). But I didn't know he was here (cuz he was working over in the main house).

Immediately after transferring some 15,000 files (to complete the upgrade), I launched the forums to test-n-see if everything was working hunky-dory.

At that very moment, the ISP dude here disconected our wireless gateway, which gave me a bizarre error I'd never seen before .. something like » "Dude, your gateway is completely trashed. Better contact your Internet Service Provider for help."

I panicked. The thought ran thru my head » "Oh my God. I screwed up the forums so bad that they trashed my router gateway .. (which is physically impossible, if you think about it) .. but you know how disorienting untimely error messages can be .. when you're already on edge.

Updated the VPS guide, which is now 20 pages .. tho the last two are incomplete. I can probably finish it in 25 pages. (No hurry.)

Installed Ruby on Rails today, on my laptop, where it seems to be working fine. Also installed RoR on the Rad VPS, but it seems to be having trouble there. (Problems identified.)

Ruby is a programming (scripting) language (not unlike PHP), known to have elegant syntax. Some even call it artistic.

Rails is a Web Application Framework (not unlike the Zend Framework for PHP) which is built with (and based on) the Ruby scripting language.